ANSI-89 Query Mode (‘traditional mode’) uses the * wildcard character, ANSI-92 Query Mode (‘SQL Server compatibility mode’) uses the % character. These modes are specific to ACE/Jet and bear only a passing resemblance to the ANSI/ISO SQL-89 and SQL-92 Standards. To modify them in Microsoft Access 2019 for a specific database, do the following: Open … Continue reading ANSI Query mode